Microsoft SQL Course

"Embark on a journey to master Microsoft SQL with our comprehensive course. From fundamental concepts to advanced techniques, you'll delve into relational databases, SQL syntax, and database management essentials. Discover how to query data, manipulate tables, and optimize performance, while gaining hands-on experience with SQL Server tools. Whether you're a beginner or seeking to enhance your skills, this course provides the knowledge and practical insights to excel in SQL development and database administration."

• Section 1 24:15

  • 1: 1a Introduction 03:28
  • 2: 1b Course Curriculum 06:55
  • 3: 1c How to get course requirements 01:41
  • 4: 1d Getting started on Windows, Linux or Docker 00:57
  • 5: 1e How to ask great questions 01:19
  • 6: 1f FAQ’s 01:08
  • 7: 1g source code file 08:47

• Section 2 43:03

  • 8: 2a Section Introduction 01:42
  • 9: 2b Microsoft SQL Server Installation 18:34
  • 10: 2c SQL Server Management Studio (SSMS) Installation 08:28
  • 11: 2d How to connect MS SQL (Windows Authentication) 03:40
  • 12: 2e How to connect MS SQL (SQL Server Authentication) 03:13
  • 13: 2f Download and Restore Sample Database 07:26

• Section 3 42:50

  • 14: 3c Creating Database 04:54
  • 15: 3d SQL Data Types 03:23
  • 16: 3e Column Data Types on SSMS 03:55
  • 17: 3f Creating Table 09:09
  • 18: 3g Overview of Primary Key and Foreign Key 04:04
  • 19: 3h Primary Key 04:05
  • 20: 3i Foreign Key 06:51
  • 21: 3j Creating Temporary tables 06:29

• Section 4 17:31

  • 22: 4a Section Introduction 00:48
  • 23: 4b Insert statement 08:25
  • 24: 4c Update statement 05:06
  • 25: 4d Delete statement 03:12

• Section 5 18:08

  • 26: 5a Section Introduction 00:54
  • 27: 5b CREATE table statement 02:58
  • 28: 5c DROP statement 02:10
  • 29: 5d ALTER statement 05:27
  • 30: 5e TRUNCATE statement 04:04
  • 31: 5f COMMENT in query 00:54
  • 32: 5g RENAME 01:41

• Section 6 14:13

  • 33: 6a Create Database user 03:54
  • 34: 6b GRANT permissions 06:09
  • 35: 6c REVOKE permissions 04:10

• Section 7 19:15

  • 36: 7a Section Introduction 01:13
  • 37: 7b SQL Statement basic 03:18
  • 38: 7c SELECT Statement 07:23
  • 39: 7d SELECT DISTINCT 02:42
  • 40: 7e SELECT with column headings 02:34
  • 41: 7f Column AS statement 02:05

• Section 8 10:55

  • 42: 8a SELECT WHERE Clause – theory 03:40
  • 43: 8b SELECT WHERE Clause – practical 07:15

• Section 9 13:47

  • 44: 9a Sum() 08:00
  • 45: 9b Min()-Max() 05:47

• Section 10 26:35

  • 46: 10a Order By statement 05:25
  • 47: 10b SELECT TOP clause in SQL 04:05
  • 48: 10c BETWEEN command 08:08
  • 49: 10d IN operator 04:04
  • 50: 10e Wildcard Characters and LIKE 04:53

• Section 11 13:21

  • 51: 11a Section Introduction 01:10
  • 52: 11b Group by – theory 03:11
  • 53: 11c Group by – practical 05:28
  • 54: 11d HAVING statement 03:32

• Section 12 26:43

  • 55: 12f Full outer join 01:21
  • 56: 12g Union 02:46
  • 57: 12h Cross join 03:10
  • 58: 12i Query Exercise 01:05
  • 59: 12j Solution for Query Exercise 01:08
  • 60: 12a Overview of Joins 01:56
  • 61: 12b What are Joins 02:15
  • 62: 12c Inner join 07:55
  • 63: 12d Left outer join 02:49
  • 64: 12e Right outer join 02:18

• Section 13 21:18

  • 65: 13a Section introduction 00:54
  • 66: 13b Check constraint 06:54
  • 67: 13c NOT NULL constraint 08:28
  • 68: 13d UNIQUE constraint 05:02

• Section 14 07:03

  • 69: 14a Creating Views 03:58
  • 70: 14b Reporting with multiple tables 03:05

• Section 15 26:40

  • 71: 15a Section Introduction 00:51
  • 72: 15b Timestamp 04:26
  • 73: 15c Extract from timestamp 03:11
  • 74: 15d Mathematical scalar functions 03:50
  • 75: 15e String functions 04:55
  • 76: 15f Sub Query 03:09
  • 77: 15g SELECT with calculations 06:18

• Section 16 09:05

  • 78: 16a Create stored procedure 04:36
  • 79: 16b Stored procedure with parameter 04:29

• Section 17 14:58

  • 80: 17a Section Introduction 01:07
  • 81: 17b Import Flat File 05:03
  • 82: 17c Import .csv or excel file 02:40
  • 83: 17d Export Data to Excel or any format 06:08

• Section 18 08:24

  • 84: 18a Section Introduction 00:59
  • 85: 18b Creating Database backup 03:51
  • 86: 18c Restoring Database backup 03:34

Mastering Microsoft SQL: From Beginner to Advanced

#### Module 1: Introduction to Relational Databases and SQL
- Overview of relational databases and SQL
- Understanding the importance of SQL in database management
- Setting up SQL Server and Management Studio

#### Module 2: SQL Basics
- Introduction to SQL syntax and structure
- Retrieving data with SELECT statements
- Filtering data with a WHERE clause
- Sorting data with ORDER BY clause

#### Module 3: Working with Tables
- Creating and modifying tables with CREATE TABLE and ALTER TABLE statements
- Understanding data types and constraints
- Inserting, updating, and deleting data with INSERT, UPDATE, and DELETE statements

#### Module 4: Querying Data with SQL
- Retrieving data from multiple tables with joins
- Grouping and aggregating data with GROUP BY and aggregate functions
- Filtering grouped data with a HAVING clause
- Subqueries and derived tables for complex data retrieval

#### Module 5: Manipulating Data
- Advanced data manipulation techniques with Common Table Expressions (CTEs)
- Using Window Functions for advanced data analysis
- Performing set operations with UNION, INTERSECT, and EXCEPT
- Using MERGE statement for data synchronization

#### Module 6: Stored Procedures and Functions
- Creating and executing stored procedures
- Passing parameters to stored procedures
- Creating user-defined functions for custom logic

#### Module 7: Triggers and Transactions
- Understanding triggers and their usage
- Creating and managing triggers for data integrity
- Working with transactions to ensure data consistency

#### Module 8: Advanced SQL Topics
- Working with XML and JSON data
- Implementing error handling and transactions
- Understanding query optimization techniques
- Introduction to indexing for performance tuning

#### Module 9: Security and Permissions
- Managing security and permissions in SQL Server
- Granting and revoking permissions on objects
- Securing sensitive data with encryption and masking

#### Module 10: Integration Services (SSIS) Basics
- Introduction to SQL Server Integration Services (SSIS)
- Creating and managing SSIS packages for data integration
- Performing ETL (Extract, Transform, Load) operations with SSIS

#### Module 11: Reporting Services (SSRS) Basics
- Introduction to SQL Server Reporting Services (SSRS)
- Creating and deploying reports with SSRS
- Customizing report layouts and formatting options

#### Module 12: Analysis Services (SSAS) Basics
- Introduction to SQL Server Analysis Services (SSAS)
- Building and deploying multidimensional and tabular models
- Performing data analysis with SSAS cubes and data mining

#### Module 13: Final Project and Review
- Applying learned concepts to a final project
- Reviewing key topics covered in the course
- Setting goals for further exploration and mastery

- Video Tutorials: Step-by-step video tutorials for each module.
- Hands-on Exercises: Practical exercises to reinforce learning.
- Quizzes and Assessments: Assessments to test understanding and retention of course material.
- Supplementary Resources: Additional reading materials, cheat sheets, and reference guides.
- Community Support: Access to a community forum for asking questions and sharing insights with fellow learners.

No prior knowledge or experience required

Currently there are no Q&As for this course. Be the first to ask a question.

Reed Courses Certificate of Completion

Digital certificate - Included